##
## Attaching package: 'dplyr'
##
## The following objects are masked from 'package:stats':
##
## filter, lag
##
## The following objects are masked from 'package:base':
##
## intersect, setdiff, setequal, union
## Warning: package 'ggplot2' was built under R version 3.2.3
##
## Attaching package: 'plotly'
##
## The following object is masked from 'package:ggplot2':
##
## last_plot
##
## The following object is masked from 'package:graphics':
##
## layout
##
## 88888 94000 94014 94101 94106 94113 94119 94120 94125 94126 94138 94142
## 8 1 2 154 43 200 120 106 110 138 1 1
## 94147 94158 94159 94160 94165 94199 99999 <NA>
## 4 17 1 1 1 13 36 342
##
## 88888 94000 94014 94101 94102 94103 94104 94105 94106 94107 94108 94109
## 8 1 2 154 1349 861 39 199 43 998 854 2273
## 94110 94111 94112 94113 94114 94115 94116 94117 94118 94119 94120 94121
## 3240 332 2387 200 1741 1462 1777 1954 1595 120 106 1596
## 94122 94123 94124 94125 94126 94127 94129 94130 94131 94132 94133 94134
## 2109 1121 1170 110 138 770 62 36 1261 967 964 1211
## 94138 94142 94147 94158 94159 94160 94165 94199 99999 <NA>
## 1 1 4 17 1 1 1 13 36 2521
## Source: local data frame [390 x 3]
## Groups: zipcode
##
## zipcode year n()
## 1 88888 2009 8
## 2 94000 1998 1
## 3 94014 2000 2
## 4 94101 2000 1
## 5 94101 2004 2
## 6 94101 2013 151
## 7 94102 1996 71
## 8 94102 1997 25
## 9 94102 1998 75
## 10 94102 1999 91
## .. ... ... ...
## [1] "integer"
Ideas: Things by zipcode over time Parents vs not % of respondents with kids over the years (maybe also by zip) Peoples own neighborhoods vs city wide (by zip too) Correlation between cleanliness, lights, etc. and safety Match up Zipcode info with census data see how incomes etc. play in Tell the story of the mission & SOMA since people talk about them changing so much Mission zipcode: 94110 SOMA: 94103 Do changes over the years match up with 311 call learnings? All kinds of demographics info. Does it line up with Census data? People per household, up or down? Own or rent home What do people say in open ended comments? Transit exploration
Questions: How do I do the weighting for finweigh Neighborhoods mapped to zips? In 2015 they switched to using districts intead of zipcodes… whyyyyyy
Page 133 -135 have a lot of methodology info
regression table Arima, forcast package
6 and 7 should probably be made NA
## swclcity swclnbrd
## swclcity 1.0000000 0.4475023
## swclnbrd 0.4475023 1.0000000
## Warning: Removed 12 rows containing missing values (geom_point).
## Warning: Removed 10 rows containing missing values (geom_point).
This needs to be a lot more digestable to be useful 2015, zip = NA remove after finding out why
Lolllllllll Need a lot of zip cleaning and a better plan than facets
The groupings in this changes so need to account for that.
## Source: local data frame [35,806 x 276]
##
## id year mode language finweigh swclnbrd swclcity stclnbrd
## 1 201510164 2015 1 1 1.010167 2 NA 3
## 2 201511631 2015 1 1 0.853352 3 NA 4
## 3 201511630 2015 1 1 0.853352 5 NA 5
## 4 201511629 2015 1 1 1.010167 5 NA 4
## 5 201511628 2015 1 1 0.695734 4 NA 4
## 6 201511627 2015 1 1 0.853352 NA NA NA
## 7 201511626 2015 1 1 1.598978 NA NA NA
## 8 201511625 2015 1 1 1.720994 NA NA NA
## 9 201511624 2015 1 1 0.740437 3 NA 3
## 10 201511623 2015 1 1 1.010167 NA NA NA
## .. ... ... ... ... ... ... ... ...
## Variables not shown: stclcity (chr), stpvnbrd (int), stpvcity (chr),
## treesnbr (chr), treescit (chr), cityligh (int), signsig (int), infrastr
## (chr), willtree (chr), parkgr (int), parkfa (int), reccon (int),
## recproad (chr), recproch (chr), parkvis (int), fqctpk (chr), recpart
## (int), recint (chr), recstaff (int), athfield (int), golfcour (chr),
## walkbike (chr), aqucent (chr), recpract (int), recparsy (chr), parkrecs
## (int), libbo (int), libsta (int), libacadu (chr), libac18 (chr), libmai
## (int), libbra (int), fqmain (chr), fqbran (chr), fqany (chr), libonlin
## (int), onlibsvc (int), conmalib (int), connelib (int), libsystm (chr),
## muncon (chr), muntim (int), muncle (int), munfar (chr), munsaf (int),
## muncom (chr), muncou (int), munrid (chr), fqmuni (chr), prmytrsp (chr),
## oftnbike (chr), bikelane (chr), bikesept (chr), nicescap (chr), bikesafe
## (chr), noencbik (chr), safdnb (int), safnnb (int), safcro (chr), crimvi
## (chr), reptvi (chr), crimnv (chr), reptnv (chr), k0to5 (int), k6to13
## (int), k14to17 (int), kids (int), knosch (int), kpubsch (int), kprisch
## (int), kqschl (int), ccare (int), asprog (int), enrich (int), yempl
## (int), couns (chr), ccare02 (chr), ccare35 (chr), afschpro (chr),
## kidex613 (chr), kidsumpr (int), empcarde (chr), kid1418 (chr), tutoring
## (int), gnocart (chr), grnfood (chr), grnpaper (chr), grnyard (chr),
## grncart (chr), discart (chr), distime (chr), dismess (chr), dispest
## (chr), disown (chr), disother (chr), rhpmhdst (chr), rhpmhbl (chr),
## rhpmhdeaf (chr), rhpmhcil (chr), rhpmhmen (chr), rhpmhcog (chr),
## enrolhea (chr), healinsu (chr), resinspr (chr), empinspr (chr), spoinspr
## (chr), medinspr (chr), othinspr (chr), pchome (chr), nethome (chr),
## netdsl (chr), netdial (chr), netwire (chr), netdk (chr), ipurch (chr),
## iconv (chr), iprod (chr), ipric (chr), itax (chr), complib (chr),
## comppark (chr), compwd (chr), compcafe (chr), compwork (chr), compnone
## (chr), socnetwk (chr), shdwvide (chr), dlivedsf (int), dage (int),
## dethnic (int), deduc (int), dempsum (chr), dincome (int), dhouse (int),
## ownrenhm (int), gender (int), dsexornt (int), zipcode (chr), district
## (int), region (chr), movesf (int), chgemp5y (chr), coverexp (chr),
## covdebt (chr), covsave (chr), covwork (chr), covnone (chr), senrmeal
## (chr), senrpers (chr), senrbene (chr), senrsocl (chr), general (int),
## cityweb (chr), citycable (chr), citysfchr (chr), citysfex (chr),
## citycomn (chr), citytv (chr), cityweek (chr), cityrad (chr), citypub
## (chr), webgovsv (chr), cont311 (int), use311sv (int), info311 (int),
## svc311 (int), infowebm (int), svcwebmo (int), broch (chr), radtv (chr),
## frico (chr), comgr (chr), other (chr), thres (chr), contempl (chr),
## deptcont (chr), easedept (chr), courprof (chr), qresolve (chr), custosvc
## (chr), emplyctr (chr), assitcbo (chr), assitclg (chr), citinfo (chr),
## prpdfood (int), prpdfam (int), prpdcpr (int), prpdnone (int), tapqual
## (chr), taptast (chr), budfirep (chr), budhlthp (chr), budhump (chr),
## budmentp (chr), budrecp (chr), budpolp (chr), budmunp (chr), budstrtp
## (chr), budfired (chr), budhlthd (chr), budhumd (chr), budmentd (chr),
## budrecd (chr), budpold (chr), budmund (chr), budstrtd (chr), opencomm
## (chr), HH (chr), wtrswr (int), swcndnhd (int), swcndcity (chr),
## netlibsvc (int), trspwlk (int), trsppub (int), trspbike (int), trsptaxi
## (int), trspdaln (int), trspcpl (int), trspptns (int), prpdcinfo (int),
## prpdctool (int), iamobile (chr), asprivpub (chr), asfrpay (chr),
## smrprivpub (chr), smrfrpy (chr), senior (int), srfood (int), srfdprvpb
## (chr), srfdfrpy (chr), srphcr (int), srphcrpvpb (chr), srphcrfrpy (chr),
## srsocial (int), srsclpvpb (chr), srsclfrpy (chr), hrd311 (int), trnsgndr
## (chr), dethhisp (chr), darab (chr), dothlnghm (chr), dtrbctylb (chr),
## dempstat (chr), langint (chr), group (int), walkhike (int), trspuber
## (int), mun12mth (int), munmgmtcro (int), disablephys (int), disablement
## (int), v128 (chr), com1 (int), com2 (int), com3 (int), com4 (int), com5
## (int), com6 (chr), mixed_1 (int), mixed_2 (int), mixed_3 (int), mixed_4
## (int), prpdother (int), primlang_1 (int), primlang_2 (int), primlang_3
## (int), primlang_4 (int), emplytype (int)
## Warning: Removed 60 rows containing missing values (geom_point).
## Warning: Removed 52 rows containing missing values (geom_path).
##
## 88888 94000 94014 94101 94106 94113 94119 94120 94125 94126 94138 94142
## 8 1 2 154 43 200 120 106 110 138 1 1
## 94147 94158 94159 94160 94165 94199 99999
## 4 17 1 1 1 13 36